package com.cwj.dao.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import common.entity.middle.course_video_teacher;
import common.entity.teacher;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface course_video_teacherMapper extends BaseMapper<course_video_teacher> {
    @Select("select  * \n" +
            "from teacher \n" +
            "where teacher.id in (select teacher_id \n" +
            "    from course_video_teacher\n" +
            "        where course_id=#{course_id} and course_video_id=#{id});")
    List<teacher> getCourse_videoTeacher(Integer course_id, String id);
}
